UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YYnodCh5fmVY6rbrUcZX/5jCeQ8WM4E5lzgnJnrnaW0='
WHERE
key_id = 'd0da2a9ad60ba6f9ec605641f5ba63b60c551b3744513eb967ff13cf210c3d89'
AND (
token = 'YYnodCh5fmVY6rbrUcZX/5jCeQ8WM4E5lzgnJnrnaW0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)