UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'afEHgA+8Qn562MekjX2BkBJpdaAISfSfqbiM/XhOPsQ='
WHERE
key_id = '59ec90795c0e91d0641d426290a110ac362d03cefa4becc02a970b184d9bb2a3'
AND (
token = 'afEHgA+8Qn562MekjX2BkBJpdaAISfSfqbiM/XhOPsQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)