UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Chw08iEtH7RqKpTWxcFvGP0AOgaQPIAdbkBXEWTmFiU='
WHERE
key_id = '278590c0f6d4eef404e52ec0ca182b940ea5fbb3d62342e7e33a09f30ce4aca4'
AND (
token = 'Chw08iEtH7RqKpTWxcFvGP0AOgaQPIAdbkBXEWTmFiU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)