UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xl2y7xccj5kszNVnGox53ZyHX1KXaFj0xOQGcxT/wpA='
WHERE
key_id = '26fd59e9859757d817b45116e557984a309cbe31c0eea1073946f049d040bff7'
AND (
token = 'Xl2y7xccj5kszNVnGox53ZyHX1KXaFj0xOQGcxT/wpA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)