UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HC0g5HaKRYb22sHByDZbEdLXBrbfV5maLpsIZt3E/yI='
WHERE
key_id = 'b2e131b4738d9b1897d7a2caf8a0dc6563affa55a67e49eecdd6932bd410765c'
AND (
token = 'HC0g5HaKRYb22sHByDZbEdLXBrbfV5maLpsIZt3E/yI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)