UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SNi3YZKbXIbugjE22gn6/CjngrAmCdx4b9EYrPasvPI='
WHERE
key_id = 'ac96609e9f669a223dbf499d81806944532de4c6f39c0b38ed9c1af35a06406d'
AND (
token = 'SNi3YZKbXIbugjE22gn6/CjngrAmCdx4b9EYrPasvPI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)