UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P7vXfqV2dwKqrjAO6Rpg7NKqvhS7bEEP2lFvPwOAqAU='
WHERE
key_id = 'fd456a253881c9c3c7625133455f081c043a965cdfd1db13f6701b86e294a021'
AND (
token = 'P7vXfqV2dwKqrjAO6Rpg7NKqvhS7bEEP2lFvPwOAqAU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)