UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ytB8dnZvlI/F5fu5rxfznpv62V+WV0s0y2+N1EIRfOE=' 
WHERE 
  key_id = '21e343194b1ce15f2e959f13d437185249434c41b4739ec3aa55d2f6da3f526b' 
  AND (
    token = 'ytB8dnZvlI/F5fu5rxfznpv62V+WV0s0y2+N1EIRfOE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028