UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'RPuyII3pTA03QyGIOKEHc9Y+gVUtpixLfEQiL40Ty6g=' 
WHERE 
  key_id = 'f918bc3330c5ca0bf3fe5b474b42759c08064fdf32406a73348d261f6c549274' 
  AND (
    token = 'RPuyII3pTA03QyGIOKEHc9Y+gVUtpixLfEQiL40Ty6g=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023