UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hwA9JhRBkZlvo/fVypNNV9Q387UxUJt1bO0As+QSs9Y='
WHERE
key_id = '5414c0c8050a2987fa0491ec8c65d061c81d204c675d83372aa97a9456a90d8a'
AND (
token = 'hwA9JhRBkZlvo/fVypNNV9Q387UxUJt1bO0As+QSs9Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)