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