UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9uHKpb+N+1fjnwZA+x0IlT7zkk7OUdKRDrAnroI1W3k='
WHERE
key_id = 'a663710ada5ddd62efe27053e905955d949d83c202b38cdf2f16baf9ad0ffdef'
AND (
token = '9uHKpb+N+1fjnwZA+x0IlT7zkk7OUdKRDrAnroI1W3k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)