UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'BcOI4M5/jxLwCfXXYCE1IckfDr50Fr7tfK9gzIxesVw=' 
WHERE 
  key_id = '4fe27e475d5c509bd12411c7ffbc196ff9afeb3f816ef8e99e7dcf237f22ecef' 
  AND (
    token = 'BcOI4M5/jxLwCfXXYCE1IckfDr50Fr7tfK9gzIxesVw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00053