UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k7fvdPW4q2ZY9UV9vj9tf8xwily4MRmvqn+yOwR13+4='
WHERE
key_id = '32eca5745482fc70da1c60e7abb40b7db2d934e42c4d1919fc56e33a77f0a2df'
AND (
token = 'k7fvdPW4q2ZY9UV9vj9tf8xwily4MRmvqn+yOwR13+4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)