UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'JfNcwsHljDXA/ZwFEDfjy054ff7TdQF44zGTpJiACoQ=' 
WHERE 
  key_id = 'cc99efbf0487c05f5eb8b60ef1c07b07d478fdc66e25b9210a88ac6bfa1a581b' 
  AND (
    token = 'JfNcwsHljDXA/ZwFEDfjy054ff7TdQF44zGTpJiACoQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021