UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'bI73exCy8DT/ZodGAGMvHbgD4DOEI4mTrVFuP7KV8+A=' 
WHERE 
  key_id = '6ecc2b68cfd64268af60698ecf73ceefc22af7fff9f45001cbc22b42a5e7fdc7' 
  AND (
    token = 'bI73exCy8DT/ZodGAGMvHbgD4DOEI4mTrVFuP7KV8+A=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021