UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'rz5cXHEguvnANlEP7Z4YTz4Lr4M9z10vCq4eTlDPLUI=' 
WHERE 
  key_id = 'a32b6b7b4b9af69624523ef0f8da6ae19de33880d3d46de5b0ff2122c303cc6d' 
  AND (
    token = 'rz5cXHEguvnANlEP7Z4YTz4Lr4M9z10vCq4eTlDPLUI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023