UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P2JWTQ9YDeUIZlHh2ejm+mx/ztvCosaKYmXUJbo9b18='
WHERE
key_id = '27eff4495f3ecd1e7ac56e9f9c3fdf06ba51cb3626907dd378d5cff41a2f6a1b'
AND (
token = 'P2JWTQ9YDeUIZlHh2ejm+mx/ztvCosaKYmXUJbo9b18='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)