UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'fH+a7zXPiySK6wQyiJ+S+nk3HLntlTA3BW9cfSi8Afk=' 
WHERE 
  key_id = 'a5dae60e017585ae92dc3192f1f4c09c4e6447510a2b24fc841919388c783a38' 
  AND (
    token = 'fH+a7zXPiySK6wQyiJ+S+nk3HLntlTA3BW9cfSi8Afk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00018