UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fJDY28eIMecIhzqaV4s8mEEls6ugIVANfp6tvMBVQmE='
WHERE
key_id = 'e3a616ea11853bfa78c820a43f42a7260bc4c8deda8dfa60f6949714b23c3611'
AND (
token = 'fJDY28eIMecIhzqaV4s8mEEls6ugIVANfp6tvMBVQmE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)