UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'UF8yDboOKEmJekIyyoXNLjdY7UIoCp1xUWOOfIG/JFE=' 
WHERE 
  key_id = '2ebaa9b001875941e35e2e1b55c23597bdcd18bd51a4893e5cd15bed84010dde' 
  AND (
    token = 'UF8yDboOKEmJekIyyoXNLjdY7UIoCp1xUWOOfIG/JFE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025