UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xJ4MFfkNqrt8qLcocnPbDslLs1M6eJgW+L+lQnEWXao='
WHERE
key_id = '8c49b0e62f115913e257d0abd995aa163eb7b2673fc532e2f1a5bb3678d5a4a4'
AND (
token = 'xJ4MFfkNqrt8qLcocnPbDslLs1M6eJgW+L+lQnEWXao='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)