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