UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B8AorUJYmhWP250Bldy5+ZhAopqxcWzB+v1Iozf52e8='
WHERE
key_id = '4f00b7ac989a30035c30de2002b89c1ca3cc454c31595cb4c63278e67998c9a7'
AND (
token = 'B8AorUJYmhWP250Bldy5+ZhAopqxcWzB+v1Iozf52e8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)