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