UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'a779s9UxL1rCbqLZxtYXndZQTMdhOT0JXezR7pOHYm8=' 
WHERE 
  key_id = '713e32c6b19018a2f6f72bdcd2ba47a1e89ee4e323cf450a03045df9621e7485' 
  AND (
    token = 'a779s9UxL1rCbqLZxtYXndZQTMdhOT0JXezR7pOHYm8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023