UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aU+cYjzgdLCBuGr6hdsmzsqfAt99mgm986Ah8r8u1bA='
WHERE
key_id = 'bb1ec1aa1c3d3cddc20312b95eb2d636572d127a26151a40691dd70da739e332'
AND (
token = 'aU+cYjzgdLCBuGr6hdsmzsqfAt99mgm986Ah8r8u1bA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)