UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Tbv7g3KD3KZzOKKmuHWhU36aopMiU98PicJwxSwf75g='
WHERE
key_id = '7d465d0ae6cd234b4df16881aa1923434ae49516b74e27ad17c2ce7d1c26f827'
AND (
token = 'Tbv7g3KD3KZzOKKmuHWhU36aopMiU98PicJwxSwf75g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)