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

Query time 0.00024