UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XSY89keNS6GZ3uxlfHZaNP8XwA/aixp9Ir1HogYYTsI='
WHERE
key_id = 'b8c6375986eaf7c7547e9d07bb78c9d01d7ee9d54af997fb3856fdf175336562'
AND (
token = 'XSY89keNS6GZ3uxlfHZaNP8XwA/aixp9Ir1HogYYTsI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)