UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p4Km+sr1NWTjwWvCebgZFuQl6JmK6S1zPRsyHhdkwRY='
WHERE
key_id = 'e834d2d219e649b5548250951d0032489e3c4963dd22c6c4c45941ba7f10fa26'
AND (
token = 'p4Km+sr1NWTjwWvCebgZFuQl6JmK6S1zPRsyHhdkwRY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)