UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '4+CfCj75PEro3xDnLwV49TDAKA72+5Dn4q9vtSGH3Jk=' 
WHERE 
  key_id = '70764ef8d38c4e58a42fedffea08ab9b97f3ce8a059c8b1c6584d13037de2f1e' 
  AND (
    token = '4+CfCj75PEro3xDnLwV49TDAKA72+5Dn4q9vtSGH3Jk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022