UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'pW2jCXGY6fyp9I/mBimuIpYLeCSsex+nWtFj+IrkS44=' 
WHERE 
  key_id = '4acb06a6d0b44cd5ec9e6b82c1c54f159c36ff191dd51d146522eb951f81e102' 
  AND (
    token = 'pW2jCXGY6fyp9I/mBimuIpYLeCSsex+nWtFj+IrkS44=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00048