UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CkYrv0iG4r+b5IiAVbmRiEo93kAWh3MFw+h/VtjezvY='
WHERE
key_id = 'b33be606b6eb72cd4d95b39578e85b47f0f7bcb14faf8884ba1b68617c7c6216'
AND (
token = 'CkYrv0iG4r+b5IiAVbmRiEo93kAWh3MFw+h/VtjezvY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)