UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7Sw0Cps2dcI6b04lUOc6FKgJiB3huQNL0x0XoD8jGwc='
WHERE
key_id = 'd9ffa499d85b7e6276c90ebbf0d4ddeff69811450e71583e3f0dcdc900d9c9ff'
AND (
token = '7Sw0Cps2dcI6b04lUOc6FKgJiB3huQNL0x0XoD8jGwc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)