UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yQtI0trx7rR86pRpRPFuPQj4s3k+eboPGk+dssCuSAE='
WHERE
key_id = 'a1ac563926ba73a1fcc75b91b852d847301c2496a5c25e2ec42abe8e5506664e'
AND (
token = 'yQtI0trx7rR86pRpRPFuPQj4s3k+eboPGk+dssCuSAE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)