UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '4bn/oYonKWdQLaada2O8M3gpGGn+T4SlZQH69XvbdMI=' 
WHERE 
  key_id = '483057efae49419cfdbbc827e6535b833f24371610bbbb9fa3aa07bab08325b8' 
  AND (
    token = '4bn/oYonKWdQLaada2O8M3gpGGn+T4SlZQH69XvbdMI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034