UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'GCDrSsvTt0EWccw43214oC5AXvfEYueIkgE5giCNXu4=' 
WHERE 
  key_id = '81ad1fbb3cbe318d4f23425872a3b87cc4596507b982c1c0465f8e65a8072246' 
  AND (
    token = 'GCDrSsvTt0EWccw43214oC5AXvfEYueIkgE5giCNXu4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030